create external table jms_ods.operate_lost_t2_config(
 id             string  comment '主键id'
 ,target_rate    string  comment '处理率目标值'
--,status         string
 ,modify_by      string  comment '修改人'
 ,modify_time    string  comment '修改时间'
 ,delete_flag    string  comment '删除标识 已删除：y，未删除：n'
 )comment 't-2疑似遗失处理率配置'
PARTITIONED BY (dt STRING COMMENT '更新/创建日期 (yyyy-MM-dd)')
STORED AS PARQUET 
LOCATION '/dw/hive/jms_ods.db/external/operate_lost_t2_config'
TBLPROPERTIES (
  'parquet.column.index.access'='true'
)